<%@ page import="java.sql.*, studentportal.*"%>
<html>

<head>
 
<title>New Page 1</title>
</head>

<body topmargin=0 leftmargin=0 background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<font face="Trebuchet MS, Arial, Helvetica">
<table border="0" width="100%">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65">&nbsp;</td>
  </tr>
</table>
<table border="0" width="100%">
  <tr>
    <td width="23%">
      <p align="center"><a href="AdminStudentHome.html">Students</a></td>
    <td width="23%">
      <p align="center"><a href="AdminFacultyHome.html">Faculties</a></td>

    <td width="20%">
      <p align="center"><a href="AdminNotificaiton.jsp">Notifications</a></td>

    <td width="20%">
      <a href="AdminDeptHome.html">Departments</a></td>

    <td width="20%">
      <p align="center"><a href="AdminCourseHome.html">Courses</a></td>

    <td width="20%">
      <p align="center"><a href="AdminSemesterHome.html">Semesters</a></td>

    <td width="20%">
      <p align="center"><a href="AdminSubjectHome.html">Subjects</a></td>

    <td width="20%">
      <a href="AdminDesignationHome.html">Designation</a></td>

	  <td width="20%">
      <p align="center"><a href="Home.html">Home</a></td>
  </tr>
</table>


<%
					
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					System.out.println("After Statement");
					String sr="select * from ADMIN_CORPORATE";
					System.out.println(sr);
					ResultSet rs=st.executeQuery(sr);
%>
</font>
<div align="center">
    <center>
    <table border="1" width="68%" bordercolor="#0000FF">
			<tr>
					<th>Corporate ID</th>
					<th>Notification ID </th>
					<th>Adv Date</th>
					<th> Adv Last Date</th>
					<th> Notification</th>
			</tr>
			<%
					while(rs.next())
					{
			%>
						<tr>
								<td><%=rs.getString(1)%></td>
								<%String noteid=rs.getString(2);%>
								<td><%=noteid%></td>
								<td><%=rs.getDate(3)%></td>
								<td><%=rs.getDate(4)%></td>						
								<td><%=rs.getString(5)%></td>						
						</tr>
			<%
					}con.close();
			%>
	</table>
  
</body>
  
</html>
